400 |
Can I change the format of date to be shown in the control
with AxList1 do begin with Columns do begin Add('Default'); with (Add('Format.1') as EXLISTLib.Column) do begin ComputedField := '%0'; FormatColumn := 'dateF(value) replace `/` with `-`'; end; with (Add('Format.2') as EXLISTLib.Column) do begin ComputedField := '%0'; Def[EXLISTLib.DefColumnEnum.exCaptionFormat] := TObject(1); FormatColumn := '`<b>`+ shortdate(value) + `</b> ` + timeF(value)'; end; with (Add('Format.3') as EXLISTLib.Column) do begin ComputedField := '%0'; Def[EXLISTLib.DefColumnEnum.exCaptionFormat] := TObject(1); FormatColumn := '( dateF(value) replace `/` with `-` ) + ` <b>`+ ( weekday(value) case ( 0 : `Su`; 1 : `Mo`; 2 : `Tu`; 3 : `We`; 4 : `Th`; 5 : `F' + 'r`; 6 : `Sa`) )'; end; end; with Items do begin Add('1/1/2001 10:00:00 AM'); Add('1/2/2001 10:00:00 AM'); end; end |
399 |
How can I put a picture on the cell's background (method 3)
with AxList1 do begin VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn'); VisualAppearance.Add(2,'CP:1 0 0 -164 0'); with Columns do begin Add('column'); with (Add('column') as EXLISTLib.Column) do begin Alignment := EXLISTLib.AlignmentEnum.CenterAlignment; HeaderAlignment := EXLISTLib.AlignmentEnum.CenterAlignment; end; end; with Items do begin i := Add(Nil); SelectableItem[i] := False; Caption[i,TObject(1)] := 'caption'; CellBackColor[i,TObject(1)] := $2000000; end; end |
398 |
How can I put a picture on the cell's background (method 2)
with AxList1 do begin VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn'); with Columns do begin Add('column'); Add('column'); end; with Items do begin i := Add(Nil); SelectableItem[i] := False; Caption[i,TObject(1)] := 'caption'; CellBackColor[i,TObject(1)] := $1000000; CellPicture[i,TObject(1)] := AxList1.ExecuteTemplate('loadpicture(`c:\exontrol\images\auction.gif`)'); CellPictureWidth[i,TObject(1)] := 128; CellPictureHeight[i,TObject(1)] := AxList1.DefaultItemHeight; end; end |
397 |
How can I put a picture on the cell's background (method 1)
with AxList1 do begin VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn'); with Columns do begin Add('column'); with (Add('column') as EXLISTLib.Column) do begin Alignment := EXLISTLib.AlignmentEnum.CenterAlignment; HeaderAlignment := EXLISTLib.AlignmentEnum.CenterAlignment; end; end; with Items do begin i := Add(Nil); SelectableItem[i] := False; Caption[i,TObject(1)] := 'caption'; CellBackColor[i,TObject(1)] := $1000000; end; end |
396 |
How do I access the cells, or how do I get the values in the columns
with AxList1 do begin with Columns do begin Add('C1'); Add('C2'); Add('C3'); end; with Items do begin h := Add('Item 1'); Caption[h,TObject(1)] := 'SubItem 1.1'; Caption[h,TObject(2)] := 'SubItem 1.2'; OutputDebugString( Caption[h,TObject(2)] ); end; end |
395 |
How can I apply the same ConditionalFormat on more than 1(one) column (multiple columns and not on item)
with AxList1 do begin BeginUpdate(); with ConditionalFormats.Add('1','K1') do begin BackColor := $ff; ApplyTo := EXLISTLib.FormatApplyToEnum($1); end; with ConditionalFormats.Add('1','K2') do begin BackColor := $ff; ApplyTo := EXLISTLib.FormatApplyToEnum($2); end; MarkSearchColumn := False; DrawGridLines := EXLISTLib.GridLinesEnum($fffffffc Or Integer(EXLISTLib.GridLinesEnum.exVLines)); with Columns do begin Add('Column 1'); Add('Column 2'); Add('Column 3'); end; with Items do begin Add(Nil); Add(Nil); Add(Nil); end; EndUpdate(); end |
394 |
How can I get the list of items as they are displayed
|
393 |
Is posible to reduce the size of the picture to be shown in the column's caption
with AxList1 do begin BeginUpdate(); set_HTMLPicture('pic1','c:\exontrol\images\zipdisk.gif'); HeaderHeight := 48; (Columns.Add('DefaultSize') as EXLISTLib.Column).HTMLCaption := 'Default-Size <img>pic1</img> Picture'; (Columns.Add('CustomSize') as EXLISTLib.Column).HTMLCaption := 'Custom-Size <img>pic1:16</img> Picture'; EndUpdate(); end |
392 |
How can I change the color, font, bold etc for the items/cells in the same column or for the entire column
with AxList1 do begin BeginUpdate(); MarkSearchColumn := False; with ConditionalFormats.Add('1',Nil) do begin Bold := True; ForeColor := $ff; ApplyTo := EXLISTLib.FormatApplyToEnum($1); end; Columns.Add('C1'); with (Columns.Add('C2') as EXLISTLib.Column) do begin HeaderBold := True; HTMLCaption := '<fgcolor=FF0000>C2'; end; with Items do begin Caption[Add(TObject(10)),TObject(1)] := TObject(11); Caption[Add(TObject(12)),TObject(1)] := TObject(13); end; EndUpdate(); end |
391 |
Is it possible to limit the height of item while resizing the row
// AddItem event - Occurs after a new Item is inserted to Items collection. procedure TWinForm1.AxList1_AddItem(sender: System.Object; e: AxEXLISTLib._IListEvents_AddItemEvent); begin with AxList1 do begin Items.ItemMinHeight[e.item] := 18; Items.ItemMaxHeight[e.item] := 72; end end; with AxList1 do begin BeginUpdate(); ItemsAllowSizing := EXLISTLib.ItemsAllowSizingEnum.exResizeItem; ScrollBySingleLine := False; BackColorAlternate := Color.FromArgb(240,240,240); Columns.Add('Names'); with Items do begin Add('Mantel'); Add('Mechanik'); Add('Motor'); Add('Murks'); Add('Märchen'); Add('Möhren'); Add('Mühle'); end; Columns.Item[TObject(0)].SortOrder := EXLISTLib.SortOrderEnum.SortAscending; EndUpdate(); end |
390 |
Can I specify un-sortable items so they keep their position once the user sorts the columns
with AxList1 do begin (Columns.Add('Def') as EXLISTLib.Column).SortType := EXLISTLib.SortTypeEnum.SortNumeric; with Items do begin SortableItem[Add('Unsortable')] := False; Add(TObject(1)); Add(TObject(2)); Add(TObject(3)); end; end |
389 |
The item is not getting selected when clicking the cell's checkbox. What should I do
// CellStateChanged event - Fired after cell's state is changed. procedure TWinForm1.AxList1_CellStateChanged(sender: System.Object; e: AxEXLISTLib._IListEvents_CellStateChangedEvent); begin with AxList1 do begin Items.SelectItem[e.itemIndex] := True; end end; with AxList1 do begin (Columns.Add('Check') as EXLISTLib.Column).Def[EXLISTLib.DefColumnEnum.exCellHasCheckBox] := TObject(True); with Items do begin Add(TObject(0)); Add(TObject(1)); Add(TObject(2)); Add(TObject(3)); end; end |
388 |
Does your control supports multiple lines tooltip
|
387 |
How can I prevent highlighting the column from the cursor - point
with AxList1 do begin VisualAppearance.Add(1,'gBFLBCJwBAEHhEJAEGg4BI0IQAAYAQGKIYBkAKBQAGaAoDDUOQzQwAAxDKKUEwsACEIrjKCYVgOHYYRrIMYgBCMJhLEoaZLhEZRQiqDYtRDFQBSDDcPw/EaRZohGaYJg' + 'EgI='); set_Background(EXLISTLib.BackgroundPartEnum.exCursorHoverColumn,$1000000); (Columns.Add('S') as EXLISTLib.Column).Width := 32; (Columns.Add('Level 1') as EXLISTLib.Column).LevelKey := TObject(1); (Columns.Add('Level 2') as EXLISTLib.Column).LevelKey := TObject(1); (Columns.Add('Level 3') as EXLISTLib.Column).LevelKey := TObject(1); (Columns.Add('E1') as EXLISTLib.Column).Width := 32; (Columns.Add('E2') as EXLISTLib.Column).Width := 32; (Columns.Add('E3') as EXLISTLib.Column).Width := 32; (Columns.Add('E4') as EXLISTLib.Column).Width := 32; end |
386 |
Is there any option to show the tooltip programmatically
|
385 |
Is it possible to prevent covering the colors by selected rows
|
384 |
Can I use PNG images to display pictures in the control
|
383 |
Does your control support conditional format and computed fields
with AxList1 do begin BeginUpdate(); MarkSearchColumn := False; with ConditionalFormats do begin with Add('%1 >4',Nil) do begin Bold := True; StrikeOut := True; ForeColor := $ff; ApplyTo := EXLISTLib.FormatApplyToEnum($1); end; with Add('%2 > 4',Nil) do begin Bold := True; StrikeOut := True; ForeColor := $ff; ApplyTo := EXLISTLib.FormatApplyToEnum($2); end; with Add('%3 > 4',Nil) do begin Bold := True; StrikeOut := True; ForeColor := $ff; ApplyTo := EXLISTLib.FormatApplyToEnum($3); end; end; with Columns do begin Add('Name'); with (Add('A') as EXLISTLib.Column) do begin SortType := EXLISTLib.SortTypeEnum.SortNumeric; AllowSizing := False; Width := 36; FormatColumn := 'len(value) ? value + '' +'''; end; with (Add('B') as EXLISTLib.Column) do begin SortType := EXLISTLib.SortTypeEnum.SortNumeric; AllowSizing := False; Width := 36; FormatColumn := 'len(value) ? value + '' +'''; end; with (Add('C') as EXLISTLib.Column) do begin SortType := EXLISTLib.SortTypeEnum.SortNumeric; AllowSizing := False; Width := 36; FormatColumn := 'len(value) ? value + '' ='''; end; with (Add('A+B+C') as EXLISTLib.Column) do begin SortType := EXLISTLib.SortTypeEnum.SortNumeric; AllowSizing := False; Width := 64; ComputedField := '%1+%2+%3'; FormatColumn := '((0:=dbl(value)) < 10? ''<fgcolor=808080><font ;7>'' :''<b>'') + currency(=:0)'; Def[EXLISTLib.DefColumnEnum.exCaptionFormat] := TObject(1); end; end; with Items do begin h1 := Add('Item 1'); Caption[h1,TObject(1)] := TObject(7); Caption[h1,TObject(2)] := TObject(3); Caption[h1,TObject(3)] := TObject(1); h1 := Add('Item 2'); Caption[h1,TObject(1)] := TObject(2); Caption[h1,TObject(2)] := TObject(5); Caption[h1,TObject(3)] := TObject(12); h1 := Add('Item 3'); Caption[h1,TObject(1)] := TObject(2); Caption[h1,TObject(2)] := TObject(2); Caption[h1,TObject(3)] := TObject(4); h1 := Add('Item 4'); Caption[h1,TObject(1)] := TObject(2); Caption[h1,TObject(2)] := TObject(9); Caption[h1,TObject(3)] := TObject(4); end; EndUpdate(); end |
382 |
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
with AxList1 do begin BeginUpdate(); ScrollBars := EXLISTLib.ScrollBarsEnum.DisableBoth; with Columns do begin Add('C1'); Add('C2'); Add('C3'); Add('C4'); Add('C5'); Add('C6'); Add('C7'); Add('C8'); end; RightToLeft := True; EndUpdate(); end |
381 |
Can I display the cell's check box after the text
with AxList1 do begin with (Columns.Add('Column') as EXLISTLib.Column) do begin Def[EXLISTLib.DefColumnEnum.exCellHasCheckBox] := TObject(True); Def[EXLISTLib.DefColumnEnum.exCellDrawPartsOrder] := 'caption,check'; end; with Items do begin CellHasCheckBox[Add('Caption 1'),TObject(0)] := True; CellHasCheckBox[Add('Caption 2'),TObject(0)] := True; end; end |
380 |
Can I change the order of the parts in the cell, as checkbox after the text, and so on
with AxList1 do begin Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' + 'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' + 'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' + 'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA='); (Columns.Add('Column') as EXLISTLib.Column).Def[EXLISTLib.DefColumnEnum.exCellDrawPartsOrder] := 'caption,check,icon,icons,picture'; with Items do begin h := Add('Text'); CellImage[h,TObject(0)] := 1; CellHasCheckBox[h,TObject(0)] := True; end; end |
379 |
Can I have an image displayed after the text. Can I get that effect without using HTML content
|
378 |
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
with AxList1 do begin BeginUpdate(); ScrollBars := EXLISTLib.ScrollBarsEnum.DisableBoth; with Columns do begin Add('C1'); Add('C2'); Add('C3'); Add('C4'); Add('C5'); Add('C6'); Add('C7'); Add('C8'); end; RightToLeft := True; EndUpdate(); end |
377 |
How can I change the foreground color for a particular column
|
376 |
How can I change the background color for a particular column
|
375 |
How can I display the column using currency format and enlarge the font for certain values
|
374 |
How can I highlight only parts of the cells
|
373 |
How can I get the number of occurrences of a specified string in the cell
with AxList1 do begin Columns.Add(''); with (Columns.Add('occurrences') as EXLISTLib.Column) do begin ComputedField := 'lower(%0) count ''o'''; FormatColumn := '''contains '' + value + '' of \''o\'' chars'''; end; with Items do begin h := Add('Root'); Add('Child 1 oooof the root'); Add('Child 2'); Add('Child 3'); end; end |
372 |
How can I display dates in my format
|
371 |
How can I display dates in short format
|
370 |
How can I display dates in long format
|
369 |
How can I display only the right part of the cell
with AxList1 do begin Columns.Add(''); with (Columns.Add('Right') as EXLISTLib.Column) do begin ComputedField := '%0 right 2'; FormatColumn := '''"'' + value + ''"'''; end; with Items do begin h := Add('Root'); Add('Child 1'); Add('Child 2'); Add('SChild 3'); end; end |
368 |
How can I display only the left part of the cell
|
367 |
How can I display true or false instead 0 and -1
with AxList1 do begin (Columns.Add('Boolean') as EXLISTLib.Column).FormatColumn := 'value != 0 ? ''true'' : ''false'''; with Items do begin Add(TObject(True)); Add(TObject(False)); Add(TObject(True)); Add(TObject(0)); Add(TObject(1)); end; end |
366 |
How can I display icons or images instead numbers
with AxList1 do begin Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' + 'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' + 'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' + 'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA='); with (Columns.Add('Icons') as EXLISTLib.Column) do begin Def[EXLISTLib.DefColumnEnum.exCaptionFormat] := TObject(1); FormatColumn := '''The cell displays the icon <img>''+value+''</img> instead '' + value'; end; with Items do begin Add(TObject(1)); Add(TObject(2)); Add(TObject(3)); end; end |
365 |
How can I display the column using currency
|
364 |
Is is possible to use HTML tags to display in the filter caption
with AxList1 do begin BeginUpdate(); FilterBarPromptVisible := True; FilterBarCaption := 'This is a bit of text being displayed in the filter bar.'; Columns.Add(''); with Items do begin Add('Item 1'); Add('Item 2'); Add('Item 3'); end; EndUpdate(); end |
363 |
How can I find the number of items after filtering
|
362 |
How can I change the filter caption
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; FilterBarPromptType := Integer(EXLISTLib.FilterPromptEnum.exFilterPromptWords) Or Integer(EXLISTLib.FilterPromptEnum.exFilterPromptContainsAll); FilterBarPromptPattern := 'london robert'; FilterBarCaption := '<r>Found: ... '; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; with Items do begin h0 := Add('Nancy Davolio'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Andrew Fuller'); Caption[h0,TObject(1)] := 'Vice President, Sales'; Caption[h0,TObject(2)] := 'Tacoma'; SelectItem[h0] := True; h0 := Add('Janet Leverling'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Kirkland'; h0 := Add('Margaret Peacock'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Redmond'; h0 := Add('Steven Buchanan'); Caption[h0,TObject(1)] := 'Sales Manager'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Michael Suyama'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Robert King'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Laura Callahan'); Caption[h0,TObject(1)] := 'Inside Sales Coordinator'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Anne Dodsworth'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; end; EndUpdate(); end |
361 |
While using the filter prompt is it is possible to use wild characters
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; FilterBarPromptType := EXLISTLib.FilterPromptEnum.exFilterPromptPattern; FilterBarPromptPattern := 'lon* seat*'; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; with Items do begin h0 := Add('Nancy Davolio'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Andrew Fuller'); Caption[h0,TObject(1)] := 'Vice President, Sales'; Caption[h0,TObject(2)] := 'Tacoma'; SelectItem[h0] := True; h0 := Add('Janet Leverling'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Kirkland'; h0 := Add('Margaret Peacock'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Redmond'; h0 := Add('Steven Buchanan'); Caption[h0,TObject(1)] := 'Sales Manager'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Michael Suyama'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Robert King'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Laura Callahan'); Caption[h0,TObject(1)] := 'Inside Sales Coordinator'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Anne Dodsworth'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; end; EndUpdate(); end |
360 |
How can I list all items that contains any of specified words, not necessary at the beggining
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; FilterBarPromptType := Integer(EXLISTLib.FilterPromptEnum.exFilterPromptStartWords) Or Integer(EXLISTLib.FilterPromptEnum.exFilterPromptContainsAny); FilterBarPromptPattern := 'london davolio'; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; with Items do begin h0 := Add('Nancy Davolio'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Andrew Fuller'); Caption[h0,TObject(1)] := 'Vice President, Sales'; Caption[h0,TObject(2)] := 'Tacoma'; SelectItem[h0] := True; h0 := Add('Janet Leverling'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Kirkland'; h0 := Add('Margaret Peacock'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Redmond'; h0 := Add('Steven Buchanan'); Caption[h0,TObject(1)] := 'Sales Manager'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Michael Suyama'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Robert King'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Laura Callahan'); Caption[h0,TObject(1)] := 'Inside Sales Coordinator'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Anne Dodsworth'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; end; EndUpdate(); end |
359 |
How can I list all items that contains any of specified words, not strings
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; FilterBarPromptType := Integer(EXLISTLib.FilterPromptEnum.exFilterPromptWords) Or Integer(EXLISTLib.FilterPromptEnum.exFilterPromptContainsAny); FilterBarPromptPattern := 'london nancy'; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; with Items do begin h0 := Add('Nancy Davolio'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Andrew Fuller'); Caption[h0,TObject(1)] := 'Vice President, Sales'; Caption[h0,TObject(2)] := 'Tacoma'; SelectItem[h0] := True; h0 := Add('Janet Leverling'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Kirkland'; h0 := Add('Margaret Peacock'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Redmond'; h0 := Add('Steven Buchanan'); Caption[h0,TObject(1)] := 'Sales Manager'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Michael Suyama'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Robert King'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Laura Callahan'); Caption[h0,TObject(1)] := 'Inside Sales Coordinator'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Anne Dodsworth'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; end; EndUpdate(); end |
358 |
How can I list all items that contains all specified words, not strings
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; FilterBarPromptType := Integer(EXLISTLib.FilterPromptEnum.exFilterPromptWords) Or Integer(EXLISTLib.FilterPromptEnum.exFilterPromptContainsAll); FilterBarPromptPattern := 'london robert'; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; with Items do begin h0 := Add('Nancy Davolio'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Andrew Fuller'); Caption[h0,TObject(1)] := 'Vice President, Sales'; Caption[h0,TObject(2)] := 'Tacoma'; SelectItem[h0] := True; h0 := Add('Janet Leverling'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Kirkland'; h0 := Add('Margaret Peacock'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Redmond'; h0 := Add('Steven Buchanan'); Caption[h0,TObject(1)] := 'Sales Manager'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Michael Suyama'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Robert King'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Laura Callahan'); Caption[h0,TObject(1)] := 'Inside Sales Coordinator'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Anne Dodsworth'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; end; EndUpdate(); end |
357 |
I've noticed that the filtering by prompt is not case sensitive, is is possible to make it case sensitive
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; FilterBarPromptType := Integer(EXLISTLib.FilterPromptEnum.exFilterPromptCaseSensitive) Or Integer(EXLISTLib.FilterPromptEnum.exFilterPromptContainsAny); FilterBarPromptPattern := 'Anne'; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; with Items do begin h0 := Add('Nancy Davolio'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Andrew Fuller'); Caption[h0,TObject(1)] := 'Vice President, Sales'; Caption[h0,TObject(2)] := 'Tacoma'; SelectItem[h0] := True; h0 := Add('Janet Leverling'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Kirkland'; h0 := Add('Margaret Peacock'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Redmond'; h0 := Add('Steven Buchanan'); Caption[h0,TObject(1)] := 'Sales Manager'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Michael Suyama'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Robert King'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Laura Callahan'); Caption[h0,TObject(1)] := 'Inside Sales Coordinator'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Anne Dodsworth'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; end; EndUpdate(); end |
356 |
Is it possible to list only items that ends with any of specified strings
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; FilterBarPromptType := EXLISTLib.FilterPromptEnum.exFilterPromptEndWith; FilterBarPromptColumns := '0'; FilterBarPromptPattern := 'Fuller'; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; with Items do begin h0 := Add('Nancy Davolio'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Andrew Fuller'); Caption[h0,TObject(1)] := 'Vice President, Sales'; Caption[h0,TObject(2)] := 'Tacoma'; SelectItem[h0] := True; h0 := Add('Janet Leverling'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Kirkland'; h0 := Add('Margaret Peacock'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Redmond'; h0 := Add('Steven Buchanan'); Caption[h0,TObject(1)] := 'Sales Manager'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Michael Suyama'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Robert King'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Laura Callahan'); Caption[h0,TObject(1)] := 'Inside Sales Coordinator'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Anne Dodsworth'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; end; EndUpdate(); end |
355 |
Is it possible to list only items that ends with any of specified strings
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; FilterBarPromptType := EXLISTLib.FilterPromptEnum.exFilterPromptEndWith; FilterBarPromptColumns := '0'; FilterBarPromptPattern := 'Fuller'; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; with Items do begin h0 := Add('Nancy Davolio'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Andrew Fuller'); Caption[h0,TObject(1)] := 'Vice President, Sales'; Caption[h0,TObject(2)] := 'Tacoma'; SelectItem[h0] := True; h0 := Add('Janet Leverling'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Kirkland'; h0 := Add('Margaret Peacock'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Redmond'; h0 := Add('Steven Buchanan'); Caption[h0,TObject(1)] := 'Sales Manager'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Michael Suyama'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Robert King'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Laura Callahan'); Caption[h0,TObject(1)] := 'Inside Sales Coordinator'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Anne Dodsworth'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; end; EndUpdate(); end |
354 |
Is it possible to list only items that starts with any of specified strings
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; FilterBarPromptType := EXLISTLib.FilterPromptEnum.exFilterPromptStartWith; FilterBarPromptColumns := '0'; FilterBarPromptPattern := 'An M'; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; with Items do begin h0 := Add('Nancy Davolio'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Andrew Fuller'); Caption[h0,TObject(1)] := 'Vice President, Sales'; Caption[h0,TObject(2)] := 'Tacoma'; SelectItem[h0] := True; h0 := Add('Janet Leverling'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Kirkland'; h0 := Add('Margaret Peacock'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Redmond'; h0 := Add('Steven Buchanan'); Caption[h0,TObject(1)] := 'Sales Manager'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Michael Suyama'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Robert King'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Laura Callahan'); Caption[h0,TObject(1)] := 'Inside Sales Coordinator'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Anne Dodsworth'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; end; EndUpdate(); end |
353 |
Is it possible to list only items that starts with specified string
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; FilterBarPromptType := EXLISTLib.FilterPromptEnum.exFilterPromptStartWith; FilterBarPromptColumns := '0'; FilterBarPromptPattern := 'A'; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; with Items do begin h0 := Add('Nancy Davolio'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Andrew Fuller'); Caption[h0,TObject(1)] := 'Vice President, Sales'; Caption[h0,TObject(2)] := 'Tacoma'; SelectItem[h0] := True; h0 := Add('Janet Leverling'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Kirkland'; h0 := Add('Margaret Peacock'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Redmond'; h0 := Add('Steven Buchanan'); Caption[h0,TObject(1)] := 'Sales Manager'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Michael Suyama'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Robert King'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Laura Callahan'); Caption[h0,TObject(1)] := 'Inside Sales Coordinator'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Anne Dodsworth'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; end; EndUpdate(); end |
352 |
How can I specify that the list should include any of the seqeunces in the pattern
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; FilterBarPromptType := EXLISTLib.FilterPromptEnum.exFilterPromptContainsAny; FilterBarPromptPattern := 'london seattle'; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; with Items do begin h0 := Add('Nancy Davolio'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Andrew Fuller'); Caption[h0,TObject(1)] := 'Vice President, Sales'; Caption[h0,TObject(2)] := 'Tacoma'; SelectItem[h0] := True; h0 := Add('Janet Leverling'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Kirkland'; h0 := Add('Margaret Peacock'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Redmond'; h0 := Add('Steven Buchanan'); Caption[h0,TObject(1)] := 'Sales Manager'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Michael Suyama'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Robert King'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Laura Callahan'); Caption[h0,TObject(1)] := 'Inside Sales Coordinator'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Anne Dodsworth'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; end; EndUpdate(); end |
351 |
How can I specify that all sequences in the filter pattern must be included in the list
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; FilterBarPromptType := EXLISTLib.FilterPromptEnum.exFilterPromptContainsAll; FilterBarPromptPattern := 'london manager'; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; with Items do begin h0 := Add('Nancy Davolio'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Andrew Fuller'); Caption[h0,TObject(1)] := 'Vice President, Sales'; Caption[h0,TObject(2)] := 'Tacoma'; SelectItem[h0] := True; h0 := Add('Janet Leverling'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Kirkland'; h0 := Add('Margaret Peacock'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Redmond'; h0 := Add('Steven Buchanan'); Caption[h0,TObject(1)] := 'Sales Manager'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Michael Suyama'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Robert King'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Laura Callahan'); Caption[h0,TObject(1)] := 'Inside Sales Coordinator'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Anne Dodsworth'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; end; EndUpdate(); end |
350 |
How do I change at runtime the filter prompt
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; FilterBarPromptPattern := 'london manager'; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; with Items do begin h0 := Add('Nancy Davolio'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Andrew Fuller'); Caption[h0,TObject(1)] := 'Vice President, Sales'; Caption[h0,TObject(2)] := 'Tacoma'; SelectItem[h0] := True; h0 := Add('Janet Leverling'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Kirkland'; h0 := Add('Margaret Peacock'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Redmond'; h0 := Add('Steven Buchanan'); Caption[h0,TObject(1)] := 'Sales Manager'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Michael Suyama'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Robert King'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Laura Callahan'); Caption[h0,TObject(1)] := 'Inside Sales Coordinator'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Anne Dodsworth'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; end; EndUpdate(); end |
349 |
How do I specify to filter only a single column when using the filter prompt
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; FilterBarPromptColumns := '2,3'; FilterBarPromptPattern := 'london'; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; with Items do begin h0 := Add('Nancy Davolio'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Andrew Fuller'); Caption[h0,TObject(1)] := 'Vice President, Sales'; Caption[h0,TObject(2)] := 'Tacoma'; SelectItem[h0] := True; h0 := Add('Janet Leverling'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Kirkland'; h0 := Add('Margaret Peacock'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Redmond'; h0 := Add('Steven Buchanan'); Caption[h0,TObject(1)] := 'Sales Manager'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Michael Suyama'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Robert King'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Laura Callahan'); Caption[h0,TObject(1)] := 'Inside Sales Coordinator'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Anne Dodsworth'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; end; EndUpdate(); end |
348 |
How do I change the prompt or the caption being displayed in the filter bar
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; FilterBarPrompt := 'changed'; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; EndUpdate(); end |
347 |
How do I enable the filter prompt feature
with AxList1 do begin BeginUpdate(); ColumnAutoResize := True; ContinueColumnScroll := False; MarkSearchColumn := False; SearchColumnIndex := 1; FilterBarPromptVisible := True; with Columns do begin (Add('Name') as EXLISTLib.Column).Width := 96; (Add('Title') as EXLISTLib.Column).Width := 96; Add('City'); end; with Items do begin h0 := Add('Nancy Davolio'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Andrew Fuller'); Caption[h0,TObject(1)] := 'Vice President, Sales'; Caption[h0,TObject(2)] := 'Tacoma'; SelectItem[h0] := True; h0 := Add('Janet Leverling'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Kirkland'; h0 := Add('Margaret Peacock'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'Redmond'; h0 := Add('Steven Buchanan'); Caption[h0,TObject(1)] := 'Sales Manager'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Michael Suyama'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Robert King'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; h0 := Add('Laura Callahan'); Caption[h0,TObject(1)] := 'Inside Sales Coordinator'; Caption[h0,TObject(2)] := 'Seattle'; h0 := Add('Anne Dodsworth'); Caption[h0,TObject(1)] := 'Sales Representative'; Caption[h0,TObject(2)] := 'London'; end; EndUpdate(); end |
346 |
Is it possible to change the style for the vertical or horizontal grid lines, in the list area
|
345 |
Is it possible to change the style for the grid lines, for instance to be solid not dotted
|
344 |
How can I filter programatically using more columns
with AxList1 do begin BeginUpdate(); MarkSearchColumn := False; with Columns do begin Add('Car'); Add('Equipment'); end; with Items do begin Caption[Add('Mazda'),TObject(1)] := 'Air Bag'; Caption[Add('Toyota'),TObject(1)] := 'Air Bag,Air condition'; Caption[Add('Ford'),TObject(1)] := 'Air condition'; Caption[Add('Nissan'),TObject(1)] := 'Air Bag,ABS,ESP'; Caption[Add('Mazda'),TObject(1)] := 'Air Bag, ABS,ESP'; Caption[Add('Mazda'),TObject(1)] := 'ABS,ESP'; end; with Columns.Item['Car'] do begin FilterType := EXLISTLib.FilterTypeEnum.exFilter; Filter := 'Mazda'; end; with Columns.Item['Equipment'] do begin FilterType := EXLISTLib.FilterTypeEnum.exPattern; Filter := '*ABS*|*ESP*'; end; ApplyFilter(); EndUpdate(); end |
343 |
How do I find an item based on my extra data
with AxList1 do begin Columns.Add('Default'); with Items do begin Add('Item 1'); Add('Item 2'); ItemData[Add('Item 3')] := TObject(1234); Add('Item 4'); ItemBold[FindItemData[TObject(1234),Nil]] := True; end; end |
342 |
How do I print the control's content
|
341 |
How can I display the currency only for not empty cells
|
340 |
Is there a function to display the number of days between two date including the number of hours
|
339 |
Is there a function to display the number of days between two date including the number of hours
|
338 |
How can I display the number of days between two dates
|
337 |
How can I get second part of the date
|
336 |
How can I get minute part of the date
|
335 |
How can I check the hour part only so I know it was afternoon
with AxList1 do begin ConditionalFormats.Add('hour(%0)>=12',Nil).Bold := True; Columns.Add('Date'); (Columns.Add('Hour') as EXLISTLib.Column).ComputedField := 'hour(%0)'; with Items do begin Add('1/11/2001 10:00:00 AM'); Add('2/22/2002 11:00:00 AM'); Add('3/13/2003 12:00:00 PM'); Add('4/14/2004 1:00:00 PM'); end; end |
334 |
What about a function to get the day in the week, or days since Sunday
|
333 |
Is there any function to get the day of the year or number of days since January 1st
|
332 |
How can I display only the day of the date
|
331 |
How can I display only the month of the date
|
330 |
How can I get only the year part from a date expression
|
329 |
Can I convert the expression to date
|
328 |
Can I convert the expression to a number, double or float
|
327 |
How can I display dates in long format
|
326 |
How can I display dates in short format
|
325 |
How can I display the time only of a date expression
|
324 |
Is there any function to display currencies, or money formatted as in the control panel
|
323 |
How can I convert the expression to a string so I can look into the date string expression for month's name
|
322 |
Can I display the absolute value or positive part of the number
|
321 |
Is there any function to get largest number with no fraction part that is not greater than the value
|
320 |
Is there any function to round the values base on the .5 value
|
319 |
How can I get or display the integer part of the cell
|
318 |
How can I display names as proper ( first leter of the word must be in uppercase, and the rest in lowercase )
|
317 |
Is there any option to display cells in uppercase
|
316 |
Is there any option to display cells in lowercase
|
315 |
How can I mark the cells that has a specified type, ie strings only
with AxList1 do begin ConditionalFormats.Add('type(%0) = 8',Nil).ForeColor := $ff; Columns.Add(''); with Items do begin h := Add('Item 1'); Add('Item 2'); Add(TObject(2)); Add('Item 4 - child'); end; end |
314 |
How can I bold the items that contains data or those who displays empty strings
with AxList1 do begin ConditionalFormats.Add('not len(%1)=0',Nil).Bold := True; Columns.Add('C1'); Columns.Add('C2'); with Items do begin h := Add('Item 1'); Add('Item 2'); hC := Add('Item 3'); Caption[hC,TObject(1)] := '1'; Add('Item 3'); end; end |
313 |
Can I change the background color for items or cells that contains a specified string
with AxList1 do begin ConditionalFormats.Add('%0 contains ''hi''',Nil).BackColor := $ff; Columns.Add(''); with Items do begin Add('Item 1'); Add('Item 2'); Add('Item 3'); Add('Item 4 - child'); end; end |
312 |
Is there any option to change the fore color for cells or items that ends with a specified string
with AxList1 do begin ConditionalFormats.Add('%0 endwith ''22''',Nil).ForeColor := $ff; Columns.Add(''); with Items do begin Add('Item 1'); Add('Item 2'); Add('Item 1.22'); Add('Item 2.22'); end; end |
311 |
How can I highlight the cells or items that starts with a specified string
with AxList1 do begin ConditionalFormats.Add('%0 startwith ''C''',Nil).Underline := True; Columns.Add(''); with Items do begin Add('Item 1'); Add('CItem 2'); Add('Item 3'); Add('Item 4'); end; end |
310 |
How can I change the foreground color for a particular column
|
309 |
How can I change the background color for a particular column
|
308 |
How can I display the column's header using multiple lines
with AxList1 do begin HeaderHeight := 128; HeaderSingleLine := False; (Columns.Add('This is just a column that should break the header.') as EXLISTLib.Column).Width := 32; Columns.Add('This is just another column that should break the header.'); end |
307 |
How can I align the text/caption on the scroll bar
with AxList1 do begin set_ScrollPartCaption(EXLISTLib.ScrollBarEnum.exHScroll,EXLISTLib.ScrollPartEnum.exLowerBackPart,'left'); set_ScrollPartCaptionAlignment(EXLISTLib.ScrollBarEnum.exHScroll,EXLISTLib.ScrollPartEnum.exLowerBackPart,EXLISTLib.AlignmentEnum.LeftAlignment); set_ScrollPartCaption(EXLISTLib.ScrollBarEnum.exHScroll,EXLISTLib.ScrollPartEnum.exUpperBackPart,'right'); set_ScrollPartCaptionAlignment(EXLISTLib.ScrollBarEnum.exHScroll,EXLISTLib.ScrollPartEnum.exUpperBackPart,EXLISTLib.AlignmentEnum.RightAlignment); ColumnAutoResize := False; Columns.Add(1); Columns.Add(2); Columns.Add(3); Columns.Add(4); Columns.Add(5); Columns.Add(6); end |
306 |
How do I select the next row/item
with AxList1 do begin Columns.Add('Column'); with Items do begin Add('Item 1'); Add('Item 2'); Add('Item 3'); SelectItem[NextVisibleItem[FocusItem]] := True; end; end |
305 |
How do I enable resizing ( changing the height ) the items at runtime
with AxList1 do begin ItemsAllowSizing := EXLISTLib.ItemsAllowSizingEnum.exResizeItem; DrawGridLines := EXLISTLib.GridLinesEnum.exHLines; ScrollBySingleLine := True; Columns.Add('Column'); Items.Add('Item 1'); with Items do begin ItemHeight[Add('Item 2')] := 48; end; Items.Add('Item 3'); Items.Add('Item 4'); end |
304 |
How do I enable resizing all the items at runtime
with AxList1 do begin ItemsAllowSizing := EXLISTLib.ItemsAllowSizingEnum.exResizeAllItems; DrawGridLines := EXLISTLib.GridLinesEnum.exHLines; Columns.Add('Column'); Items.Add('Item 1'); with Items do begin ItemHeight[Add('Item 2')] := 48; end; Items.Add('Item 3'); end |
303 |
How can I remove the filter
with AxList1 do begin with (Columns.Add('Column') as EXLISTLib.Column) do begin DisplayFilterButton := True; FilterType := EXLISTLib.FilterTypeEnum.exBlanks; end; ApplyFilter(); ClearFilter(); end |
302 |
How do I change the control's border, using your EBN files
with AxList1 do begin VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn'); Appearance := EXLISTLib.AppearanceEnum($1000000); end |
301 |
Can I change the style for break or divider line
with AxList1 do begin Columns.Add('Default'); with Items do begin Add('Item 1'); h := Add(Nil); ItemBreak[h] := EXLISTLib.BreakLineEnum.DoubleLine; SelectableItem[h] := False; Add('Item 3'); end; end |